package com.sky.mapper;

import com.sky.entity.Category;
import com.sky.entity.Setmeal;
import com.sky.entity.User;
import com.sky.vo.DishItemVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface UserSetmealMapper {

@Select("select *from setmeal where category_id=#{categoryId} and status=1")
List<Setmeal> findByid(Integer categoryId);
@Select("select setmeal_dish.copies,dish.description,dish.image,dish.name  from setmeal,setmeal_dish,dish where setmeal.id=setmeal_dish.setmeal_id and setmeal_dish.dish_id=dish.id and setmeal.id=#{id}")
    List<DishItemVO> findDish(Long id);
}
